package com.ctg.payroll2.dao.xlsImport;

import java.util.HashMap;
import java.util.List;

import com.ctg.payroll2.bean.po.exceloperator.PayInput;
import com.ctg.payroll2.bean.po.exceloperator.SocialResult;
import com.ctg.platform.util.Page;

/**
 * @author Sami
 * 
 */
public interface XlsPublicToosDAO {
	/**
	 * @param paraMap
	 * @param start
	 * @param limit
	 * @return 根据公司编码查询薪资项目
	 */
	public Page queryPayClassByCompanyCode(Object paraMap, Integer start,
			Integer limit);

	/**
	 * @param paraMap
	 * @param start
	 * @param limit
	 * @return 根据客户编码查询PayClassId
	 */
	public Page queryPayClassItemsByPayClassId(Object paraMap, Integer start,
			Integer limit);

	/**
	 * @param paraMap
	 * @param start
	 * @param limit
	 * @return 根据客户编码查询Social
	 */
	public Page querySocialByCompanyCode(Object paraMap, Integer start,
			Integer limit);

	/**
	 * @param paraMap
	 *            导入的薪资项目,如果有错误数据,允许进行删除
	 * @return
	 */
	public int deletePayInputData(Object paraMap);

	/**
	 * @param paraMap
	 *            导入的社保数据，如果没有缴纳，is_valid＝2，可以进行删除
	 * @return
	 */
	public int deleteSocialResult(Object paraMap);

	/**
	 * 查询导入的薪资项目,companyCode必填, status=1
	 * 
	 * @param paramap
	 * @param start
	 * @param limit
	 * @return
	 */
	public Page queryPayInputData(Object paramap, Integer start,
			Integer limit);

	public Integer queryPayInputDataCount(Object paramap);

	/**
	 * 查询导入的社保项目,data_come=1,companyCode 必填
	 * 
	 * @param paramap
	 * @param start
	 * @param limit
	 * @return
	 */
	public Page querySocialResult(Object paramap, Integer start,
			Integer limit);

	public Integer querySocialResultCount(Object paramap);

	/**
	 * 验证薪资导入接口的内容是否有效,返回一个List<String,Object>.内含无效的接口名字
	 * 
	 * @param paramap
	 *            接口ID,ex_interfaceid
	 * @return
	 */
	public List<HashMap<String, Object>> payClassIsValid(Object paramap);

	/**
	 * 验证社保导入接口的内容是否有效,返回一个List<String,Object>.内含无效的接口名字
	 * 
	 * @param paramap
	 *            接口ID,ex_interfaceid
	 * @return
	 */
	public List<HashMap<String, Object>> socialIsValid(Object paramap);
}
